package com.time.sky.mapper;

import com.time.sky.entity.Residence;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface ResidenceMapper {
    @Select("select * from residence r left join water w on r.wid=w.id")
    List<Residence> queryResidence();
}
